How to: Add a chart to a report.
Solution:
In the Report Design view, select the 'Insert' menu and select 'Chart'. Click on the report and follow the steps for the wizard.
1) If the Database window is not active, activate the Database window.
2) Click the 'Reports' tab in the Database window.
Reports tab
3) Select the desired report from the list box. (The selected report is highlighted.)
4) Click 'Design'. (The selected report appears in the Design view, and the floating Toolbox appears.)
5) To add a chart that is bound to data in the database, do the following:
a) Select the 'Insert' menu and select 'Chart'. (The cursor changes to a +.)
b) Position the mouse pointer on the report to select the location for the chart.
c) Click the location for the chart. (The Chart Wizard dialog box appears.)
NOTE: The size of the control defaults to a preset size. To create an unbound control of a desired size, click the location for the unbound control, press and hold down the mouse button and drag to the desired size.
d) Select the desired table or query for the bound chart.
e) Click 'Next'. (The next step of the wizard appears.)
f) Select the desired field from the 'Available Fields' list box.
g) Click >' to move the selected field to the list box on the right.
h) Repeat steps 5)f) and 5)g) for each additional field.
i) Click 'Next'. (The next step of the wizard appears.)
j) Click the desired 'Chart Type' button. (A description of each chart type appears to the right when selected.)
k) Click 'Next'. (The next step of the wizard appears.)
l) Drag-and-drop the field buttons from the right side of the screen to the left to customize the sample chart.
m) Click 'Next'. (The next step of the wizard appears.)
n) Select the first report field to link to the chart from the 'Report Fields' drop-down list.
o) Select the corresponding chart field from the 'Chart Field' drop-down list.
NOTE: This process links the data (records) in the database to the chart.
p) Click 'Next'.
q) Type a title for the chart in the 'What would you like for your chart?' box.
r) Click 'Finish'. (The chart appears on the report.)
6) To add an unbound chart to a report, do the following:
a) To insert an existing chart, do the following:
1] Click 'Unbound Object Frame' on the Toolbox.
2] Position the mouse pointer on the report to select the location for the chart.
3] Click the location for the chart on the report. (The 'Insert Object' dialog box appears.)
4] Select the 'Create From File' radio button.
5] Type the path and filename in the 'File' box.
File box
NOTE: Click 'Browse...' button to search for a file.
6] (Optional) Select the 'Link' check box to insert a link to the file.
NOTE: Any changes made to the object file that was inserted will then be reflected in the database.
7] Clear the 'Link' check box to insert the file contents as an embedded object.
NOTE: Any changes made to the object file that was inserted will then NOT be reflected in the database.
8] Click 'OK'. (The filename appears in the 'File' box.)
9] Click 'OK'. (The chart is inserted on the report.)
b) To create and insert a new object, do the following:
1] Click 'Unbound Object Frame' on the Toolbox.
2] Position the mouse pointer on the report to select the location for the object.
3] Click the location for the object on the report. (The 'Insert Object' dialog box appears.)
4] Select the 'Create New' radio button.
5] Select the desired object type from the 'Object Type' list box.
Object Type
6] Click 'OK'. (The Object Type software application is activated.)
7] Create the object using the desired application.
8] Select the 'File' menu and select 'Exit & Return to <report name> : Report'
(where <report name> is the name of the current report for inserting the object).
NOTE: Depending on the software application, select the 'File' menu and select 'Exit' may be available.
7) Select the 'File' menu and select 'Save' to save the report.